﻿CREATE TABLE [org].[CostCentre] (
    [CostCentreId]                      INT             NOT NULL,
    [CostCentreCode]                    VARCHAR (3)     NOT NULL,
    [CostCentreName]                    VARCHAR (50)    NOT NULL,
    [CostCentreDescription]             NVARCHAR (1000) NULL,
    [CostCentreFlashPnlMinThresholdGBP] DECIMAL (18, 2) NULL,
    [CostCentreFlashPnLMaxThresholdGBP] DECIMAL (18, 2) NULL,
    [CostCentreFlashManualUpload]       BIT             NOT NULL,
    [CostCentreFlashMurexUpload]        BIT             NOT NULL,
    [CostCentreStartDate]               DATE            NOT NULL,
    [CostCentreEndDate]                 DATE            NULL,
    [IsLatest]                          BIT             NOT NULL,
    [IsActive]                          BIT             NOT NULL,
    [IsInternal]                        BIT             NOT NULL,
    PRIMARY KEY CLUSTERED ([CostCentreId] ASC) WITH (ALLOW_PAGE_LOCKS = ON, ALLOW_ROW_LOCKS = ON, PAD_INDEX = OFF, IGNORE_DUP_KEY = OFF, STATISTICS_NORECOMPUTE = OFF)
);

